﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="HauntedLocations.aspx.vb" Inherits="Haunted.HauntedLocations" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p>
       <h1><b>Most Haunted Locations in The United States</h1></b> </p>
    <p>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataKeyNames="ID" DataSourceID="SqlDataSource1" AllowSorting="True">
            <Columns>
                <asp:BoundField DataField="LocationName" HeaderText="LocationName" 
                    SortExpression="LocationName" />
                <asp:BoundField DataField="Type" HeaderText="Type" SortExpression="Type" />
                <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
                <asp:BoundField DataField="Coutry" HeaderText="Coutry" 
                    SortExpression="Coutry" />
                <asp:ImageField DataImageUrlField="Picture" HeaderText="Picture">
                    <ControlStyle Height="150px" Width="200px" />
                </asp:ImageField>
                <asp:HyperLinkField DataNavigateUrlFields="ID" 
                    DataNavigateUrlFormatString="MoreDetails.aspx?ID={0}" HeaderText="MoreDetails" 
                    Text="More Details" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:HauntedLocationString %>" 
            ProviderName="<%$ ConnectionStrings:HauntedLocationString.ProviderName %>" 
            SelectCommand="SELECT * FROM [HauntedLocations]"></asp:SqlDataSource>
    <br />
</p>
</asp:Content>
